SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+discount +items +for +sale' IN BOOLEAN MODE)) AND iCityID IN (948,797,674,657,972,833,1289,810,977,578,641,1012,914,891,1107,1282,1197,16486,876,1151,771,1195,1292,1017,1055,979,882,1272,1279,16296,789,670,744,16283,877,1159,672,574,593,704,1207,820,719,1030,1066,980,923,756,759,1083,656,1220,1127,1194,16316,1131,1011,16493,1245,1273,1293,745,926,1160,632,824,733,16318,1029,16317,1154,16300,998,735,934,835,697,567,847,1065,779,862,748,601,1171,1284,1189,706,811,682,645,874,951,925,654,605,879,1248,585,16299,947,801,681,582,1285,774,787,1221,637,895,631,812,1153,899,695,848,1280,16131,1180,668,1174,1283,855,1081,886,16482,1134,16321,1058,16327,713,16114,913,1076,1148,1034,722,607,701,725,818,968,952,905,900,612,1124,1070,16494,1208,716,1025,1214,1235,832,1014,1251,721,1244,1152,671,929,16284,16485,579,831,16489,1276,666,773,711,591,611,1144,981,813,724,778,999,696,662,887,1201,16312,939,1225,712,1243,890,568) ORDER BY FIELD(iCityID, 948,797,674,657,972,833,1289,810,977,578,641,1012,914,891,1107,1282,1197,16486,876,1151,771,1195,1292,1017,1055,979,882,1272,1279,16296,789,670,744,16283,877,1159,672,574,593,704,1207,820,719,1030,1066,980,923,756,759,1083,656,1220,1127,1194,16316,1131,1011,16493,1245,1273,1293,745,926,1160,632,824,733,16318,1029,16317,1154,16300,998,735,934,835,697,567,847,1065,779,862,748,601,1171,1284,1189,706,811,682,645,874,951,925,654,605,879,1248,585,16299,947,801,681,582,1285,774,787,1221,637,895,631,812,1153,899,695,848,1280,16131,1180,668,1174,1283,855,1081,886,16482,1134,16321,1058,16327,713,16114,913,1076,1148,1034,722,607,701,725,818,968,952,905,900,612,1124,1070,16494,1208,716,1025,1214,1235,832,1014,1251,721,1244,1152,671,929,16284,16485,579,831,16489,1276,666,773,711,591,611,1144,981,813,724,778,999,696,662,887,1201,16312,939,1225,712,1243,890,568) ASC, p.tmPosted DESC LIMIT 24 discount items for sale, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Mascotte

Items for sale in Mascotte - discount items for sale

No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

Mascotte

Items for Sale

Items for sale in Mascotte - discount items for sale

Similar searches: